Record grouped bank transactions

Find this screen

Open: Cash Book > Enter Transactions > Grouped Transactions.

How to

Enter a group of customer receipts

1. Choose the Bank account you've paid the money into.
2. Choose Sales Receipt from the Posting type list.
3. Enter the following details for the overall transaction that's posted to the bank account:
   • Date
   • Reference
   • Description
   • Exchange rate (for foreign currency bank accounts).

4. Click Add. Enter the details of each customer receipt.

5. Click Save or Save and Allocate. This saves the receipt to the group, but doesn't post it.

   Note: If you allocate the receipt to an invoice, you can't edit or delete the allocated receipt.

   Each transaction is added to the list on the Group transactions screen.

6. To post the transactions, click Save.

Enter a group of supplier payments

1. Choose the Bank account you've paid the money from.
2. Choose Purchase Payment from the Posting type list.
3. Enter the following details for the overall transaction that's posted to the bank account:
   • Date
   • Reference
   • Description
   • Exchange rate (for foreign currency bank accounts).

4. Click Add. Enter the details of each supplier payment.

5. Click Save or Save and Allocate. This saves the payment to the group, but doesn't post it.

   Note: If you allocate the payment to an invoice, you can't edit or delete the allocated payment.

   Each transaction is added to the list on the Group transactions screen.

6. To post the transactions, click Save.

Enter a group of customer refunds

1. Choose the Bank account you've paid the money from.
2. Choose Sales Payment from the Posting type list.
3. Enter the following details for the overall transaction that's posted to the bank account:
   • Date
   • Reference
   • Description
   • Exchange rate (for foreign currency bank accounts).

4. Click Add. Enter the details of each customer refund.

5. Click Save or Save and Allocate. This saves the refund to the group, but doesn't post it.

   Note: If you allocate the refund, you can't edit or delete it from the group.

   Each transaction is added to the list on the Group transactions screen.

6. To post the transactions, click Save.

Enter a group of supplier refunds

1. Choose the Bank account you've paid the money into.
2. Choose Purchase Receipt from the Posting type list.
3. Enter the following details for the overall transaction that's posted to the bank account:
   • Date
   • Reference
   • Description
   • Exchange rate (for foreign currency bank accounts).

4. Click Add. Enter the details of each supplier refund.

5. Click Save or Save and Allocate. This saves the refund to the group, but doesn't post it.

   Note: If you allocate the refund, you can't edit or delete it from the group.

   Each transaction is added to the list on the Group transactions screen.

6. To post all the transactions, click Save.

Edit a transaction in the group

To amend a transaction prior to posting, select it from the list and click Edit.

To delete a transaction prior to posting, select it from the list and click Delete.

Note: You can't edit or delete a transaction if you've allocated it.

---

Useful info

About grouped transactions

Use this to enter a single amount paid in or out of your bank account that consists of several customer or supplier transactions. This is useful if you've paid a number of cheques for different customers or suppliers at once and which appear as single item on your bank statement.

When you use grouped transactions:

• Only one transaction is posted to you bank account.
• The individual payments and receipts are posted to the relevant customer or supplier accounts.
• You can allocate the receipts and payments as you enter them. However, you can't edit or delete an allocated payment or receipt.
• You have to post the grouped transactions when you enter them. You can't save them as a batch or post them later. If you want to do this, use the Batch transactions options.
• You can't enter nominal payments or receipts this way.

Foreign currency transactions

You can enter receipts or payments in a foreign currency here, provided the bank account and the receipts or payments are all in the same currency.

When you choose a foreign currency , additional cheque currency, exchange rate and bank charges boxes are displayed.

If there is an exchange rate gain or loss between the transactions, this is dealt with by Sage 200 automatically.

Enter the following additional details:

1. Currency - The customer or supplier's currency is entered by default.

2. Exchange rate - The current rate is displayed. Click to change this.

3. Bank charges - Enter if applicable. Bank charges are entered in the same currency as the bank account.

4. Save the receipt or payment:

   • To save without allocating, click Save.
   • To save and allocate it, click Save and Allocate.

---

What happens when I

Save a grouped transaction?

• All transactions have the same URN.
• A single transaction is posted to the bank account for the total value.
• Separate transactions are posted to the nominal, customer and supplier accounts.

---